import sqlite3
import math

if __name__ == '__main__':
    table_name = 'pidata'
    #conn = sqlite3.connect('d://pidata.sqlite3')
    conn = sqlite3.connect('D:\\project\\C++\\PIInterface\\bin\\sqlite3\\pidata2.sqlite3')
    c = conn.cursor()
    
    sql = 'delete from %s' % table_name
    print sql
    c.execute(sql)  
    
    conn.commit()
    
    print 'end'